package cn.cloud.butler.uploadapi.repository;

import cn.cloud.butler.uploadapi.domain.OperInformationEntity;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface OperInformationRepository extends JpaRepository<OperInformationEntity,Integer> {

    @Query(value="select * from OperInformation where MacSN = ?1 ORDER BY BeginTime DESC limit ?2,?3", nativeQuery = true)
    List<OperInformationEntity> selectByPageAndMacSn(String macSn, int start, int interval);
}
